This dialog box appears when you click Insert Summary on the Standard toolbar, or when you choose the Summary command from the Insert menu.
Use the Insert Summary dialog box to summarize the data in a field in your report.
This list contains all the summary operations available for use in your report. Select the desired operation.
This list displays the fields and formulas used in the report. Select the field that you want to summarize.
This list displays the fields and formulas used in the report. Select the field that you want to sort and group by.
This list contains four sort direction options. The default option is in ascending order. To change the sort direction, click the box to see the options, then make your selection from the list.
Select this check box if you want to calculate the percentage total of one group within a broader grouping. For example, you can show the percentage of sales in each city based on the total sales for each country.
After you select the check box, you can choose the total or group you want the comparison to be based on.
Note: The percentage option is available only when the result of a summary operation is numeric.
Select this check box to keep groups from being split across a page. This will force groups to stay together. If there is enough room to keep them on the current page, the program will print them on the current page. If there is not enough room, the program will print them on the next page.
Select this check box if you want the program to print a new group header at the top of each page if a group is spread over several pages. Otherwise, a group header prints only at the beginning of the group.
This option enables you to calculate a summary across hierarchical groupings. To set or edit Hierarchical Options for existing groups, click Hierarchical Grouping Options on the Report menu. For details, see Grouping data hierarchically.
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |